//----------------------------------------------------------------
//Tên Class: Cls_NghiepVu
//Người thực hiện: NhatTHM
//-----------------------------------------------------------------
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
namespace Library.Business {
    public partial class Get_Procerure
    {
        public static DataTable AUC_st_KhachHang_by_HeThong_LoaiHinh(string heThong, string loaiHinh)
        {
            try
            {
                return DBcommon.getDataTable_produce("AUC_st_KhachHang_by_HeThong_LoaiHinh"
                    , new SqlParameter_My().ID_HeThongNuoc(heThong)
                    , new SqlParameter_My().ID_LoaiHinhDoanhNghiep(loaiHinh)
                    );
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable AUC_st_ThongTinGia_Tao(int thang, int nam)
        {
            try
            {
                return DBcommon.getDataTable_produce("AUC_st_ThongTinGia_Tao"
                    , new SqlParameter_My().Thang(thang)
                    , new SqlParameter_My().Nam(nam)
                    );
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
       
        public static void AUC_st_HoaDonNuoc_Xoa_ID_KhachHang(int idKhachHang, int thang, int nam)
        {
            try
            {
                DBcommon.getDataTable_produce("AUC_st_HoaDonNuoc_Xoa_ID_KhachHang"
                    , new SqlParameter_My().ID_KhachHang(idKhachHang)
                    , new SqlParameter_My().Thang(thang)
                    , new SqlParameter_My().Nam(nam)
                    );
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable AUC_st_HoaDonNuoc_XuatDuLieu(string heThong, string loaiHinh, int thang, int nam)
        {
            try
            {
                return DBcommon.getDataTable_produce("AUC_st_HoaDonNuoc_XuatDuLieu"
                    , new SqlParameter_My().ID_HeThongNuoc(heThong)
                    , new SqlParameter_My().ID_LoaiHinhDoanhNghiep(loaiHinh)
                    , new SqlParameter_My().Thang(thang)
                    , new SqlParameter_My().Nam(nam)
                    );
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public static DataTable AUC_st_HoaDonNuoc_by_HeThong_LoaiHinh(string heThong, string loaiHinh, int thang, int nam)
        {
            try
            {
                return DBcommon.getDataTable_produce("AUC_st_HoaDonNuoc_by_HeThong_LoaiHinh"
                    , new SqlParameter_My().ID_HeThongNuoc(heThong)
                    , new SqlParameter_My().ID_LoaiHinhDoanhNghiep(loaiHinh)
                    , new SqlParameter_My().Thang(thang)
                    , new SqlParameter_My().Nam(nam)
                    );
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
       
        //public static DataTable st_Get_BanHang_511( DateTime ngayBatDau, DateTime ngayKetThuc )
        //{
        //    try
        //    {
        //        SqlParameter pr_1 = new SqlParameter("NgayBatDau", SqlDbType.DateTime);
        //        pr_1.Value = ngayBatDau;
        //        SqlParameter pr_2 = new SqlParameter("NgayKetThuc", SqlDbType.DateTime);
        //        pr_2.Value = ngayKetThuc;
        //        //
        //        return DBcommon.getDataTable_produce("UC_st_Get_BanHang_511", pr_1, pr_2);
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }
        //}



    }

}
